package com.sdry.mapper.zc;

import com.sdry.model.zc.ZcMaterielAndTrayEntity;

public interface ZcBindAndUnbindMapper {
	/**
	 * 绑定
	 * @param zcMaterielAndTrayEntity
	 * @return
	 */
	public int bindingMaterielAndTray(ZcMaterielAndTrayEntity zcMaterielAndTrayEntity);
	/**
	 * 解绑前查询原托盘物料
	 * @param zcMaterielAndTrayEntity
	 * @return
	 */
	public ZcMaterielAndTrayEntity selectMaterielCodeByTrayCode(ZcMaterielAndTrayEntity zcMaterielAndTrayEntity);
	/**
	 * 解绑
	 * @param zcMaterielAndTrayEntity
	 * @return
	 */
	public int unbindMaterielAndTray(ZcMaterielAndTrayEntity zcMaterielAndTrayEntity);
	/**
	 * 绑定前查询托盘是否为空
	 * @param tray_code
	 * @return
	 */
	public ZcMaterielAndTrayEntity selectMaterielAndTray(ZcMaterielAndTrayEntity zcMaterielAndTrayEntity);
	/**
	 * 托盘不为空是追加物料
	 * @param zcMaterielAndTrayEntity
	 * @return
	 */
	public int addMaterielAndTray(ZcMaterielAndTrayEntity zcMaterielAndTrayEntity);
	/**
	 * 通过产品码，规格型号查询物料id
	 * @param zcMaterielAndTrayEntity
	 * @return
	 */
	public Long selectMidByNewCode(ZcMaterielAndTrayEntity zcMaterielAndTrayEntity);
}
